KPI % 12
DAX calculation for Mortality rate
Mortality Rate = CALCULATE(DIVIDE([Total Deaths],[Total Cases],0),'COVID-19 In US'[date])+0Go to our report page to work on our card for Mortality Rate %.
1. Drag and drop card from visualization.
2. Drag and drop Mortality rate % measure from measure table in fields.
3. Add a title text and use same format through out the dashboard. (Refer step 4)
4. Customize Data label
5. Category - off
6. Boarder - on
_Last Week Total Case =
Var __Last Week= DATEADD('COVID-19 In US'[date],-7,DAY)
Return
CALCULATE(MAX('COVID-19 In US'[positive Increase]) ,
FILTER('COVID-19 In US' ,
'COVID-19 In US'[date] = __Last Week
))+0
_Last Week Total Deaths =
Var __Last Week= DATEADD('COVID-19 In US'[date],-7,DAY)
Return
CALCULATE(MAX('COVID-19 In US'[death Increase]) ,
FILTER('COVID-19 In US',
'COVID-19 In US'[date] = __Last Week
))+0
DAX calculation for Death WOW% :
Death WoW% =
VAR __Previous Week =
DIVIDE(MAX('COVID-19 In US'[_Last Week Total Deaths]),MAX('COVID-19 In US'[_Last Week Total Case]),0)
Return
DIVIDE(([Mortality Rate]- __Previous Week),__PreviousWeek,0)+0
Conditional Formatting:
Death WOW% Sign = SWITCH(TRUE(),'Measure'[Death WoW%]>0,UNICHAR(9650),
[Death WoW%]<0,UNICHAR(9660),UNICHAR(9644))&ROUND([Death WoW%],1)&"%" Death WOW% Color = IF([Death WoW%]>0,"#fa8264","#1c9407")
Steps for this report
Go to our report page to work on our card for Death WOW %.
1. Drag and drop card from visualization.
2. Drag and drop Death WOW% sign measure from measure table in fields.
3. Add a title text and use same format through out the dashboard. (Refer step 4)
4. Customize Data label
5. Category - off
6. Boarder - on
DAX calculation for Infection Rate%:
Infection Rate = CALCULATE(DIVIDE([Total Cases],[Total Infection],0),'COVID-19 In US'[date])+0Total Infection = SUM('COVID-19 in US'[total Test Results Increase])
Steps for this report
Go to our report page to work on our card for Infection Rate %.
1. Drag and drop card from visualization.
2. Drag and drop Infection rate % measure from measure table in fields.
3. Add a title text and use same format through out the dashboard. (Refer step 4)
4. Customize Data label
5. Category - off
6. Boarder - on
DAX calculation for Infection WOW% :
Infection WoW% =
VAR __Previous Week =
DIVIDE(MAX('COVID-19 In US'[_Last Week Total Case]),MAX('COVID-19 In US'[_Last Week Total Test]),0)
Return
DIVIDE(([Infection Rate]- __Previous Week),__PreviousWeek,0)+0
Calculated Columns:
_Last Week Total Test =
Var __Last Week= DATEADD('COVID-19 In US'[date],-7,DAY)
Return
CALCULATE(MAX('COVID-19 In US'[total Test Results Increase]) ,
FILTER('COVID-19 In US',
'COVID-19 In US'[date] = __Last Week
))+0
Conditional Formatting:
Infection WOW% sign = SWITCH(TRUE(),'Measure'[Infection WoW%]>0,UNICHAR(9650),
[Infection WoW%] <0,UNICHAR(9660),UNICHAR(9644))&ROUND([Infection WoW%],1)&"%"
Infection WOW% Color = IF([Infection WoW%]>0,"#fa8264","#1c9407")
Steps for this report
Go to our report page to work on our card for Infection WOW %.
1. Drag and drop card from visualization.
2. Drag and drop Infection WOW% sign measure from measure table in fields.
3. Add a title text and use same format through out the dashboard. (Refer step 4)
4. Customize Data label
5. Category - off
6. Boarder - on